﻿--获得一条通告(多单位可见)
Create proc [dbo].[proc_Notice_GetItem_s]
(
	@NId uniqueidentifier
)
as
	select 
		Id,NId,Fid,Title,Content,UpName,IsAll,IsDing,CreateTime,UpTime,CompanyId,CompanyIdList,
		(select title from notice_category where id=fid) as category
  from Notice where NId=@NId